package com.dingding.special.user.userinfo.dao.sql;

/**
 * 
 * @ClassName: GetUserInfoSQL 
 * @Description: 获取用户信息SQL类 
 * @author YHQ
 * @date 2016年8月23日 下午5:34:35
 * @since V2.4.0
 * 
 */
public class GetUserInfoSQL {

	// 获取用户信息(专车)
	public static String GET_SPECIAL_USER_INFO = "SELECT a.loginId AS userId,a.nickName,a.userTabloidAvatar FROM userdetail a WHERE a.loginId = ?";
	
	// 获取用户信息
	public static String GET_USER_INFO = "SELECT a.userId,a.nickName,a.userTabloidAvatar FROM specialuserinfo a WHERE a.userId = ?";
	
	
	// 获取用户的资料
	public static String GET_USER_DATUM = "SELECT s.age,s.nickName,s.occupation,s.origin,s.sex FROM specialuserinfo s WHERE s.userId = ?";
	
}
